Hash Match
Short Description
Hash Match builds and populates a hash table, passing the result onto the next step.
Detailed Description​
Hash Matches can be used in Joins, Distinct or Aggregates, and Union operations. The hash table is built and then populated from the first input. The second input is then used to match values already in the table. At the end of the operation, all rows are passed onto the next step.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.